Hello folks! Welcome to visit our BC Surgical Wait Times Dashboard app project repository!👏👏👏
This document (the README file) is going to give you an overview of our project. You can go straight to the part you are interested in, or just scroll down to find out more.
Links to deploy our app: (2 links to be added)
Jagdeep - BC Surgical Wait Times Dashboard
Saisree - BC Surgical Wait Times Dashboard
Song - BC Surgical Wait Times Dashboard
Roger - BC Surgical Wait Times Dashboard
Long waiting times is an important issue for health services in Canada, and the main concern is about waiting times for elective treatments [1]. Among the OECD countries, Canada’s waiting times problem ranks in the medium-high priority level, while Germany, Korea, Japan, Switzerland, and U.S rank in low priority level [2]. After the COVID-19 outbreak, tens of thousands of scheduled surgeries being cancelled or postponed across Canada, which prolonged the surgical wait times. In B.C. province, between Mar. 16 and May 18, 2020, it was estimated that 30298 elective nonurgent surgeries were either postponed or not scheduled because of the COVID-19 pandemic [3]. If we could have a public dashboard of surgical data like that of COVID-19 for the province, it will help both the patients to know the situation and the doctors as well as the health authorities to look at where improvements are most needed [4]. Our app will show these key information in a visualization way!
Our dataset comes from BC Data Catalogue–BC Surgical Wait Times.
This dataset provides information of elective surgical procedures’ wait times in British Columbia, containing the information of patients of all ages and only the scheduled surgical cases not the unscheduled ones. The data is collected quarterly at the end of each quarter from year 2009 to 2022Q1 with the following 9 variables:
On the BC Surgical Wait Times Dashboard, you can select the specific time period and the specific BC health authority, to find the key information below across the health authority during the time period:
The total waiting and completed surgical cases and the mean waiting time
The surgical efficiency and the quarter effect
The wait times of different procedures
The total waiting and completed surgical cases in different hospitals
You can also observe the impact of pandemic on the surgical efficiency of health authorities and procedures.
The app opens a dashboard that shows the information about surgical waiting times in the province of British Columbia, Canada. Users can select health authorities of BC from the buttons (eg, Northern, Interior, Vancouver Island, Vancouver Coastal etc.) and years from the slider which will update the 4 charts (proportion of completed cases, BC health authority map, Fastest/Slowest treated procedures, total waiting and completed cases of a hospital) and information cards accordingly. The proportion of completed cases chart shows quarterly distribution of completed cases of all health authorities based on the selected years. The BC health authority map highlights the geography of the selected health authority. The fastest/slowest treated procedures chart has the option to select between fastest and slowest radio buttons. The total waiting and completed cases of a hospital has a dropdown menu of different hospitals based on the selected health authority.
prototype
If you are interested in helping in any of the areas listed above or in any of the many areas that we haven’t yet thought of, here we warmly welcome you join in. Please check out our contributors’ guidelines.
Please note that it’s very important to us that we maintain a positive and supportive environment for everyone who wants to participate. When you join us we ask that you follow our code of conduct in all interactions both on and offline.
If you want to report a problem or suggest an enhancement we’d love for you to open up an issue at this github repository because then we can get right on it. But you can also contact by email.
Thank you so much for visiting the project and we do hope that you’ll join us on this critical exploration to transparent the BC surgical situation.